/*
*
* SteelProductPriceBeanExample.java
* @author 18304
* @date 2020-11-24 15:43:05
*/
package com.steel.yfmall.cloud.assistant.po.goods;

import java.util.ArrayList;
import java.util.Date;
import java.util.List;

public class SteelProductPriceBeanExample {
    /**
     * product_price
     */
    protected String orderByClause;

    /**
     * product_price
     */
    protected boolean distinct;

    /**
     * product_price
     */
    protected List<Criteria> oredCriteria;

    private Integer limit;

    private Integer offset;

    private String groupByClause;

    private String selectFields;

    /**
     * 构造查询条件:product_price
     * @Title: SteelProductPriceBeanExample
     * @Description: ( )
     * @return 返回类型 null
     * @date 2020-11-24 15:43:05
     */
    public SteelProductPriceBeanExample() {
        oredCriteria = new ArrayList<Criteria>();
    }

    /**
     * 设置排序字段:product_price
     * @Title: setOrderByClause
     * @Description: ( 设置排序字段 )
     * @param 参数说明 类型:String	名称:orderByClause 排序字段
     * @return 返回类型 null
     * @date 2020-11-24 15:43:05
     */
    public void setOrderByClause(String orderByClause) {
        this.orderByClause = orderByClause;
    }

    /**
     * 获取排序字段:product_price
     * @Title: getOrderByClause
     * @Description: ( 获取排序字段 )
     * @return 返回类型 java.lang.String
     * @date 2020-11-24 15:43:05
     */
    public String getOrderByClause() {
        return orderByClause;
    }

    /**
     * 设置过滤重复数据:product_price
     * @Title: setDistinct
     * @Description: ( 设置过滤重复数据 )
     * @param 参数说明 类型:boolean	名称:distinct 是否过滤重复数据
     * @return 返回类型 null
     * @date 2020-11-24 15:43:05
     */
    public void setDistinct(boolean distinct) {
        this.distinct = distinct;
    }

    /**
     * 是否过滤重复数据:product_price
     * @Title: isDistinct
     * @Description: ( 是否过滤重复数据 )
     * @return 返回类型 boolean
     * @date 2020-11-24 15:43:05
     */
    public boolean isDistinct() {
        return distinct;
    }

    /**
     * 获取当前的查询条件实例:product_price
     * @Title: getOredCriteria
     * @Description: ( 获取当前的查询条件实例 )
     * @return 返回类型 java.util.List<Criteria>
     * @date 2020-11-24 15:43:05
     */
    public List<Criteria> getOredCriteria() {
        return oredCriteria;
    }

    /**
     *:product_price
     * @Title: or
     * @Description: ( )
     *
     * @param 参数说明 类型:Criteria	名称:criteria 过滤条件实例
     * @return 返回类型 null
     * @date 2020-11-24 15:43:05
     */
    public void or(Criteria criteria) {
        oredCriteria.add(criteria);
    }

    /**
     *:product_price
     * @Title: or
     * @Description: ( )
     *
     * @return 返回类型 Criteria
     * @date 2020-11-24 15:43:05
     */
    public Criteria or() {
        Criteria criteria = createCriteriaInternal();
        oredCriteria.add(criteria);
        return criteria;
    }

    /**
     * 创建一个查询条件:product_price
     * @Title: createCriteria
     * @Description: ( 创建一个查询条件 )
     * @return 返回类型 Criteria
     * @date 2020-11-24 15:43:05
     */
    public Criteria createCriteria() {
        Criteria criteria = createCriteriaInternal();
        if (oredCriteria.size() == 0) {
            oredCriteria.add(criteria);
        }
        return criteria;
    }

    /**
     * 内部构建查询条件对象:product_price
     * @Title: createCriteriaInternal
     * @Description: ( 内部构建查询条件对象 )
     * @return 返回类型 Criteria
     * @date 2020-11-24 15:43:05
     */
    protected Criteria createCriteriaInternal() {
        Criteria criteria = new Criteria();
        return criteria;
    }

    /**
     * 清除查询条件:product_price
     * @Title: clear
     * @Description: ( 清除查询条件 )
     * @return 返回类型 null
     * @date 2020-11-24 15:43:05
     */
    public void clear() {
        oredCriteria.clear();
        orderByClause = null;
        distinct = false;
    }

    public void limit(Integer offset, Integer limit) {
        this.offset = offset;
        this.limit = limit;
    }

    public Integer getLimit() {
        return limit;
    }

    public void setOffset(Integer offset) {
        this.offset = offset;
    }

    public Integer getOffset() {
        return offset;
    }

    public void setGroupByClause(String groupByClause) {
        this.groupByClause = groupByClause;
    }

    public String getGroupByClause() {
        return groupByClause;
    }

    public void setSelectFields(String selectFields) {
        this.selectFields = selectFields;
    }

    public String getSelectFields() {
        return selectFields;
    }

    /**
     * @title product_price表的实体类
     * @description product_price
     * @version 1.0
     * @author 18304
     * @date 2020-11-24 15:43:05
     */
    protected abstract static class GeneratedCriteria implements java.io.Serializable {
        protected List<Criterion> criteria;

        protected GeneratedCriteria() {
            super();
            criteria = new ArrayList<Criterion>();
        }

        public boolean isValid() {
            return criteria.size() > 0;
        }

        public List<Criterion> getAllCriteria() {
            return criteria;
        }

        public List<Criterion> getCriteria() {
            return criteria;
        }

        protected void addCriterion(String condition) {
            if (condition == null) {
                throw new RuntimeException("Value for condition cannot be null");
            }
            criteria.add(new Criterion(condition));
        }

        protected void addCriterion(String condition, Object value, String property) {
            if (value == null) {
                throw new RuntimeException("Value for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value));
        }

        protected void addCriterion(String condition, Object value1, Object value2, String property) {
            if (value1 == null || value2 == null) {
                throw new RuntimeException("Between values for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value1, value2));
        }

        public Criteria andIdIsNull() {
            addCriterion("id is null");
            return (Criteria) this;
        }

        public Criteria andIdIsNotNull() {
            addCriterion("id is not null");
            return (Criteria) this;
        }

        public Criteria andIdEqualTo(Integer value) {
            addCriterion("id =", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotEqualTo(Integer value) {
            addCriterion("id <>", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdGreaterThan(Integer value) {
            addCriterion("id >", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("id >=", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdLessThan(Integer value) {
            addCriterion("id <", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdLessThanOrEqualTo(Integer value) {
            addCriterion("id <=", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdIn(List<Integer> values) {
            addCriterion("id in", values, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotIn(List<Integer> values) {
            addCriterion("id not in", values, "id");
            return (Criteria) this;
        }

        public Criteria andIdBetween(Integer value1, Integer value2) {
            addCriterion("id between", value1, value2, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotBetween(Integer value1, Integer value2) {
            addCriterion("id not between", value1, value2, "id");
            return (Criteria) this;
        }

        public Criteria andPriceTypeIsNull() {
            addCriterion("price_type is null");
            return (Criteria) this;
        }

        public Criteria andPriceTypeIsNotNull() {
            addCriterion("price_type is not null");
            return (Criteria) this;
        }

        public Criteria andPriceTypeEqualTo(String value) {
            addCriterion("price_type =", value, "priceType");
            return (Criteria) this;
        }

        public Criteria andPriceTypeNotEqualTo(String value) {
            addCriterion("price_type <>", value, "priceType");
            return (Criteria) this;
        }

        public Criteria andPriceTypeGreaterThan(String value) {
            addCriterion("price_type >", value, "priceType");
            return (Criteria) this;
        }

        public Criteria andPriceTypeGreaterThanOrEqualTo(String value) {
            addCriterion("price_type >=", value, "priceType");
            return (Criteria) this;
        }

        public Criteria andPriceTypeLessThan(String value) {
            addCriterion("price_type <", value, "priceType");
            return (Criteria) this;
        }

        public Criteria andPriceTypeLessThanOrEqualTo(String value) {
            addCriterion("price_type <=", value, "priceType");
            return (Criteria) this;
        }

        public Criteria andPriceTypeLike(String value) {
            addCriterion("price_type like", value, "priceType");
            return (Criteria) this;
        }

        public Criteria andPriceTypeNotLike(String value) {
            addCriterion("price_type not like", value, "priceType");
            return (Criteria) this;
        }

        public Criteria andPriceTypeIn(List<String> values) {
            addCriterion("price_type in", values, "priceType");
            return (Criteria) this;
        }

        public Criteria andPriceTypeNotIn(List<String> values) {
            addCriterion("price_type not in", values, "priceType");
            return (Criteria) this;
        }

        public Criteria andPriceTypeBetween(String value1, String value2) {
            addCriterion("price_type between", value1, value2, "priceType");
            return (Criteria) this;
        }

        public Criteria andPriceTypeNotBetween(String value1, String value2) {
            addCriterion("price_type not between", value1, value2, "priceType");
            return (Criteria) this;
        }

        public Criteria andPriceClassifyIsNull() {
            addCriterion("price_classify is null");
            return (Criteria) this;
        }

        public Criteria andPriceClassifyIsNotNull() {
            addCriterion("price_classify is not null");
            return (Criteria) this;
        }

        public Criteria andPriceClassifyEqualTo(String value) {
            addCriterion("price_classify =", value, "priceClassify");
            return (Criteria) this;
        }

        public Criteria andPriceClassifyNotEqualTo(String value) {
            addCriterion("price_classify <>", value, "priceClassify");
            return (Criteria) this;
        }

        public Criteria andPriceClassifyGreaterThan(String value) {
            addCriterion("price_classify >", value, "priceClassify");
            return (Criteria) this;
        }

        public Criteria andPriceClassifyGreaterThanOrEqualTo(String value) {
            addCriterion("price_classify >=", value, "priceClassify");
            return (Criteria) this;
        }

        public Criteria andPriceClassifyLessThan(String value) {
            addCriterion("price_classify <", value, "priceClassify");
            return (Criteria) this;
        }

        public Criteria andPriceClassifyLessThanOrEqualTo(String value) {
            addCriterion("price_classify <=", value, "priceClassify");
            return (Criteria) this;
        }

        public Criteria andPriceClassifyLike(String value) {
            addCriterion("price_classify like", value, "priceClassify");
            return (Criteria) this;
        }

        public Criteria andPriceClassifyNotLike(String value) {
            addCriterion("price_classify not like", value, "priceClassify");
            return (Criteria) this;
        }

        public Criteria andPriceClassifyIn(List<String> values) {
            addCriterion("price_classify in", values, "priceClassify");
            return (Criteria) this;
        }

        public Criteria andPriceClassifyNotIn(List<String> values) {
            addCriterion("price_classify not in", values, "priceClassify");
            return (Criteria) this;
        }

        public Criteria andPriceClassifyBetween(String value1, String value2) {
            addCriterion("price_classify between", value1, value2, "priceClassify");
            return (Criteria) this;
        }

        public Criteria andPriceClassifyNotBetween(String value1, String value2) {
            addCriterion("price_classify not between", value1, value2, "priceClassify");
            return (Criteria) this;
        }

        public Criteria andSalesTypeIsNull() {
            addCriterion("sales_type is null");
            return (Criteria) this;
        }

        public Criteria andSalesTypeIsNotNull() {
            addCriterion("sales_type is not null");
            return (Criteria) this;
        }

        public Criteria andSalesTypeEqualTo(String value) {
            addCriterion("sales_type =", value, "salesType");
            return (Criteria) this;
        }

        public Criteria andSalesTypeNotEqualTo(String value) {
            addCriterion("sales_type <>", value, "salesType");
            return (Criteria) this;
        }

        public Criteria andSalesTypeGreaterThan(String value) {
            addCriterion("sales_type >", value, "salesType");
            return (Criteria) this;
        }

        public Criteria andSalesTypeGreaterThanOrEqualTo(String value) {
            addCriterion("sales_type >=", value, "salesType");
            return (Criteria) this;
        }

        public Criteria andSalesTypeLessThan(String value) {
            addCriterion("sales_type <", value, "salesType");
            return (Criteria) this;
        }

        public Criteria andSalesTypeLessThanOrEqualTo(String value) {
            addCriterion("sales_type <=", value, "salesType");
            return (Criteria) this;
        }

        public Criteria andSalesTypeLike(String value) {
            addCriterion("sales_type like", value, "salesType");
            return (Criteria) this;
        }

        public Criteria andSalesTypeNotLike(String value) {
            addCriterion("sales_type not like", value, "salesType");
            return (Criteria) this;
        }

        public Criteria andSalesTypeIn(List<String> values) {
            addCriterion("sales_type in", values, "salesType");
            return (Criteria) this;
        }

        public Criteria andSalesTypeNotIn(List<String> values) {
            addCriterion("sales_type not in", values, "salesType");
            return (Criteria) this;
        }

        public Criteria andSalesTypeBetween(String value1, String value2) {
            addCriterion("sales_type between", value1, value2, "salesType");
            return (Criteria) this;
        }

        public Criteria andSalesTypeNotBetween(String value1, String value2) {
            addCriterion("sales_type not between", value1, value2, "salesType");
            return (Criteria) this;
        }

        public Criteria andStatusIsNull() {
            addCriterion("status is null");
            return (Criteria) this;
        }

        public Criteria andStatusIsNotNull() {
            addCriterion("status is not null");
            return (Criteria) this;
        }

        public Criteria andStatusEqualTo(Integer value) {
            addCriterion("status =", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusNotEqualTo(Integer value) {
            addCriterion("status <>", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusGreaterThan(Integer value) {
            addCriterion("status >", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusGreaterThanOrEqualTo(Integer value) {
            addCriterion("status >=", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusLessThan(Integer value) {
            addCriterion("status <", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusLessThanOrEqualTo(Integer value) {
            addCriterion("status <=", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusIn(List<Integer> values) {
            addCriterion("status in", values, "status");
            return (Criteria) this;
        }

        public Criteria andStatusNotIn(List<Integer> values) {
            addCriterion("status not in", values, "status");
            return (Criteria) this;
        }

        public Criteria andStatusBetween(Integer value1, Integer value2) {
            addCriterion("status between", value1, value2, "status");
            return (Criteria) this;
        }

        public Criteria andStatusNotBetween(Integer value1, Integer value2) {
            addCriterion("status not between", value1, value2, "status");
            return (Criteria) this;
        }

        public Criteria andPriceTimeIsNull() {
            addCriterion("price_time is null");
            return (Criteria) this;
        }

        public Criteria andPriceTimeIsNotNull() {
            addCriterion("price_time is not null");
            return (Criteria) this;
        }

        public Criteria andPriceTimeEqualTo(Date value) {
            addCriterion("price_time =", value, "priceTime");
            return (Criteria) this;
        }

        public Criteria andPriceTimeNotEqualTo(Date value) {
            addCriterion("price_time <>", value, "priceTime");
            return (Criteria) this;
        }

        public Criteria andPriceTimeGreaterThan(Date value) {
            addCriterion("price_time >", value, "priceTime");
            return (Criteria) this;
        }

        public Criteria andPriceTimeGreaterThanOrEqualTo(Date value) {
            addCriterion("price_time >=", value, "priceTime");
            return (Criteria) this;
        }

        public Criteria andPriceTimeLessThan(Date value) {
            addCriterion("price_time <", value, "priceTime");
            return (Criteria) this;
        }

        public Criteria andPriceTimeLessThanOrEqualTo(Date value) {
            addCriterion("price_time <=", value, "priceTime");
            return (Criteria) this;
        }

        public Criteria andPriceTimeIn(List<Date> values) {
            addCriterion("price_time in", values, "priceTime");
            return (Criteria) this;
        }

        public Criteria andPriceTimeNotIn(List<Date> values) {
            addCriterion("price_time not in", values, "priceTime");
            return (Criteria) this;
        }

        public Criteria andPriceTimeBetween(Date value1, Date value2) {
            addCriterion("price_time between", value1, value2, "priceTime");
            return (Criteria) this;
        }

        public Criteria andPriceTimeNotBetween(Date value1, Date value2) {
            addCriterion("price_time not between", value1, value2, "priceTime");
            return (Criteria) this;
        }

        public Criteria andVersionIsNull() {
            addCriterion("version is null");
            return (Criteria) this;
        }

        public Criteria andVersionIsNotNull() {
            addCriterion("version is not null");
            return (Criteria) this;
        }

        public Criteria andVersionEqualTo(String value) {
            addCriterion("version =", value, "version");
            return (Criteria) this;
        }

        public Criteria andVersionNotEqualTo(String value) {
            addCriterion("version <>", value, "version");
            return (Criteria) this;
        }

        public Criteria andVersionGreaterThan(String value) {
            addCriterion("version >", value, "version");
            return (Criteria) this;
        }

        public Criteria andVersionGreaterThanOrEqualTo(String value) {
            addCriterion("version >=", value, "version");
            return (Criteria) this;
        }

        public Criteria andVersionLessThan(String value) {
            addCriterion("version <", value, "version");
            return (Criteria) this;
        }

        public Criteria andVersionLessThanOrEqualTo(String value) {
            addCriterion("version <=", value, "version");
            return (Criteria) this;
        }

        public Criteria andVersionLike(String value) {
            addCriterion("version like", value, "version");
            return (Criteria) this;
        }

        public Criteria andVersionNotLike(String value) {
            addCriterion("version not like", value, "version");
            return (Criteria) this;
        }

        public Criteria andVersionIn(List<String> values) {
            addCriterion("version in", values, "version");
            return (Criteria) this;
        }

        public Criteria andVersionNotIn(List<String> values) {
            addCriterion("version not in", values, "version");
            return (Criteria) this;
        }

        public Criteria andVersionBetween(String value1, String value2) {
            addCriterion("version between", value1, value2, "version");
            return (Criteria) this;
        }

        public Criteria andVersionNotBetween(String value1, String value2) {
            addCriterion("version not between", value1, value2, "version");
            return (Criteria) this;
        }

        public Criteria andEffectTimeIsNull() {
            addCriterion("effect_time is null");
            return (Criteria) this;
        }

        public Criteria andEffectTimeIsNotNull() {
            addCriterion("effect_time is not null");
            return (Criteria) this;
        }

        public Criteria andEffectTimeEqualTo(Date value) {
            addCriterion("effect_time =", value, "effectTime");
            return (Criteria) this;
        }

        public Criteria andEffectTimeNotEqualTo(Date value) {
            addCriterion("effect_time <>", value, "effectTime");
            return (Criteria) this;
        }

        public Criteria andEffectTimeGreaterThan(Date value) {
            addCriterion("effect_time >", value, "effectTime");
            return (Criteria) this;
        }

        public Criteria andEffectTimeGreaterThanOrEqualTo(Date value) {
            addCriterion("effect_time >=", value, "effectTime");
            return (Criteria) this;
        }

        public Criteria andEffectTimeLessThan(Date value) {
            addCriterion("effect_time <", value, "effectTime");
            return (Criteria) this;
        }

        public Criteria andEffectTimeLessThanOrEqualTo(Date value) {
            addCriterion("effect_time <=", value, "effectTime");
            return (Criteria) this;
        }

        public Criteria andEffectTimeIn(List<Date> values) {
            addCriterion("effect_time in", values, "effectTime");
            return (Criteria) this;
        }

        public Criteria andEffectTimeNotIn(List<Date> values) {
            addCriterion("effect_time not in", values, "effectTime");
            return (Criteria) this;
        }

        public Criteria andEffectTimeBetween(Date value1, Date value2) {
            addCriterion("effect_time between", value1, value2, "effectTime");
            return (Criteria) this;
        }

        public Criteria andEffectTimeNotBetween(Date value1, Date value2) {
            addCriterion("effect_time not between", value1, value2, "effectTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeIsNull() {
            addCriterion("create_time is null");
            return (Criteria) this;
        }

        public Criteria andCreateTimeIsNotNull() {
            addCriterion("create_time is not null");
            return (Criteria) this;
        }

        public Criteria andCreateTimeEqualTo(Date value) {
            addCriterion("create_time =", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeNotEqualTo(Date value) {
            addCriterion("create_time <>", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeGreaterThan(Date value) {
            addCriterion("create_time >", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeGreaterThanOrEqualTo(Date value) {
            addCriterion("create_time >=", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeLessThan(Date value) {
            addCriterion("create_time <", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeLessThanOrEqualTo(Date value) {
            addCriterion("create_time <=", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeIn(List<Date> values) {
            addCriterion("create_time in", values, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeNotIn(List<Date> values) {
            addCriterion("create_time not in", values, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeBetween(Date value1, Date value2) {
            addCriterion("create_time between", value1, value2, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeNotBetween(Date value1, Date value2) {
            addCriterion("create_time not between", value1, value2, "createTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeIsNull() {
            addCriterion("update_time is null");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeIsNotNull() {
            addCriterion("update_time is not null");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeEqualTo(Date value) {
            addCriterion("update_time =", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeNotEqualTo(Date value) {
            addCriterion("update_time <>", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeGreaterThan(Date value) {
            addCriterion("update_time >", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeGreaterThanOrEqualTo(Date value) {
            addCriterion("update_time >=", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeLessThan(Date value) {
            addCriterion("update_time <", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeLessThanOrEqualTo(Date value) {
            addCriterion("update_time <=", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeIn(List<Date> values) {
            addCriterion("update_time in", values, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeNotIn(List<Date> values) {
            addCriterion("update_time not in", values, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeBetween(Date value1, Date value2) {
            addCriterion("update_time between", value1, value2, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeNotBetween(Date value1, Date value2) {
            addCriterion("update_time not between", value1, value2, "updateTime");
            return (Criteria) this;
        }

        public Criteria andEffectEmpNoIsNull() {
            addCriterion("effect_emp_no is null");
            return (Criteria) this;
        }

        public Criteria andEffectEmpNoIsNotNull() {
            addCriterion("effect_emp_no is not null");
            return (Criteria) this;
        }

        public Criteria andEffectEmpNoEqualTo(String value) {
            addCriterion("effect_emp_no =", value, "effectEmpNo");
            return (Criteria) this;
        }

        public Criteria andEffectEmpNoNotEqualTo(String value) {
            addCriterion("effect_emp_no <>", value, "effectEmpNo");
            return (Criteria) this;
        }

        public Criteria andEffectEmpNoGreaterThan(String value) {
            addCriterion("effect_emp_no >", value, "effectEmpNo");
            return (Criteria) this;
        }

        public Criteria andEffectEmpNoGreaterThanOrEqualTo(String value) {
            addCriterion("effect_emp_no >=", value, "effectEmpNo");
            return (Criteria) this;
        }

        public Criteria andEffectEmpNoLessThan(String value) {
            addCriterion("effect_emp_no <", value, "effectEmpNo");
            return (Criteria) this;
        }

        public Criteria andEffectEmpNoLessThanOrEqualTo(String value) {
            addCriterion("effect_emp_no <=", value, "effectEmpNo");
            return (Criteria) this;
        }

        public Criteria andEffectEmpNoLike(String value) {
            addCriterion("effect_emp_no like", value, "effectEmpNo");
            return (Criteria) this;
        }

        public Criteria andEffectEmpNoNotLike(String value) {
            addCriterion("effect_emp_no not like", value, "effectEmpNo");
            return (Criteria) this;
        }

        public Criteria andEffectEmpNoIn(List<String> values) {
            addCriterion("effect_emp_no in", values, "effectEmpNo");
            return (Criteria) this;
        }

        public Criteria andEffectEmpNoNotIn(List<String> values) {
            addCriterion("effect_emp_no not in", values, "effectEmpNo");
            return (Criteria) this;
        }

        public Criteria andEffectEmpNoBetween(String value1, String value2) {
            addCriterion("effect_emp_no between", value1, value2, "effectEmpNo");
            return (Criteria) this;
        }

        public Criteria andEffectEmpNoNotBetween(String value1, String value2) {
            addCriterion("effect_emp_no not between", value1, value2, "effectEmpNo");
            return (Criteria) this;
        }

        public Criteria andUpdateEmpNoIsNull() {
            addCriterion("update_emp_no is null");
            return (Criteria) this;
        }

        public Criteria andUpdateEmpNoIsNotNull() {
            addCriterion("update_emp_no is not null");
            return (Criteria) this;
        }

        public Criteria andUpdateEmpNoEqualTo(String value) {
            addCriterion("update_emp_no =", value, "updateEmpNo");
            return (Criteria) this;
        }

        public Criteria andUpdateEmpNoNotEqualTo(String value) {
            addCriterion("update_emp_no <>", value, "updateEmpNo");
            return (Criteria) this;
        }

        public Criteria andUpdateEmpNoGreaterThan(String value) {
            addCriterion("update_emp_no >", value, "updateEmpNo");
            return (Criteria) this;
        }

        public Criteria andUpdateEmpNoGreaterThanOrEqualTo(String value) {
            addCriterion("update_emp_no >=", value, "updateEmpNo");
            return (Criteria) this;
        }

        public Criteria andUpdateEmpNoLessThan(String value) {
            addCriterion("update_emp_no <", value, "updateEmpNo");
            return (Criteria) this;
        }

        public Criteria andUpdateEmpNoLessThanOrEqualTo(String value) {
            addCriterion("update_emp_no <=", value, "updateEmpNo");
            return (Criteria) this;
        }

        public Criteria andUpdateEmpNoLike(String value) {
            addCriterion("update_emp_no like", value, "updateEmpNo");
            return (Criteria) this;
        }

        public Criteria andUpdateEmpNoNotLike(String value) {
            addCriterion("update_emp_no not like", value, "updateEmpNo");
            return (Criteria) this;
        }

        public Criteria andUpdateEmpNoIn(List<String> values) {
            addCriterion("update_emp_no in", values, "updateEmpNo");
            return (Criteria) this;
        }

        public Criteria andUpdateEmpNoNotIn(List<String> values) {
            addCriterion("update_emp_no not in", values, "updateEmpNo");
            return (Criteria) this;
        }

        public Criteria andUpdateEmpNoBetween(String value1, String value2) {
            addCriterion("update_emp_no between", value1, value2, "updateEmpNo");
            return (Criteria) this;
        }

        public Criteria andUpdateEmpNoNotBetween(String value1, String value2) {
            addCriterion("update_emp_no not between", value1, value2, "updateEmpNo");
            return (Criteria) this;
        }

        public Criteria andUnEffectEmpNoIsNull() {
            addCriterion("un_effect_emp_no is null");
            return (Criteria) this;
        }

        public Criteria andUnEffectEmpNoIsNotNull() {
            addCriterion("un_effect_emp_no is not null");
            return (Criteria) this;
        }

        public Criteria andUnEffectEmpNoEqualTo(String value) {
            addCriterion("un_effect_emp_no =", value, "unEffectEmpNo");
            return (Criteria) this;
        }

        public Criteria andUnEffectEmpNoNotEqualTo(String value) {
            addCriterion("un_effect_emp_no <>", value, "unEffectEmpNo");
            return (Criteria) this;
        }

        public Criteria andUnEffectEmpNoGreaterThan(String value) {
            addCriterion("un_effect_emp_no >", value, "unEffectEmpNo");
            return (Criteria) this;
        }

        public Criteria andUnEffectEmpNoGreaterThanOrEqualTo(String value) {
            addCriterion("un_effect_emp_no >=", value, "unEffectEmpNo");
            return (Criteria) this;
        }

        public Criteria andUnEffectEmpNoLessThan(String value) {
            addCriterion("un_effect_emp_no <", value, "unEffectEmpNo");
            return (Criteria) this;
        }

        public Criteria andUnEffectEmpNoLessThanOrEqualTo(String value) {
            addCriterion("un_effect_emp_no <=", value, "unEffectEmpNo");
            return (Criteria) this;
        }

        public Criteria andUnEffectEmpNoLike(String value) {
            addCriterion("un_effect_emp_no like", value, "unEffectEmpNo");
            return (Criteria) this;
        }

        public Criteria andUnEffectEmpNoNotLike(String value) {
            addCriterion("un_effect_emp_no not like", value, "unEffectEmpNo");
            return (Criteria) this;
        }

        public Criteria andUnEffectEmpNoIn(List<String> values) {
            addCriterion("un_effect_emp_no in", values, "unEffectEmpNo");
            return (Criteria) this;
        }

        public Criteria andUnEffectEmpNoNotIn(List<String> values) {
            addCriterion("un_effect_emp_no not in", values, "unEffectEmpNo");
            return (Criteria) this;
        }

        public Criteria andUnEffectEmpNoBetween(String value1, String value2) {
            addCriterion("un_effect_emp_no between", value1, value2, "unEffectEmpNo");
            return (Criteria) this;
        }

        public Criteria andUnEffectEmpNoNotBetween(String value1, String value2) {
            addCriterion("un_effect_emp_no not between", value1, value2, "unEffectEmpNo");
            return (Criteria) this;
        }

        public Criteria andUnEffectDateIsNull() {
            addCriterion("un_effect_date is null");
            return (Criteria) this;
        }

        public Criteria andUnEffectDateIsNotNull() {
            addCriterion("un_effect_date is not null");
            return (Criteria) this;
        }

        public Criteria andUnEffectDateEqualTo(Date value) {
            addCriterion("un_effect_date =", value, "unEffectDate");
            return (Criteria) this;
        }

        public Criteria andUnEffectDateNotEqualTo(Date value) {
            addCriterion("un_effect_date <>", value, "unEffectDate");
            return (Criteria) this;
        }

        public Criteria andUnEffectDateGreaterThan(Date value) {
            addCriterion("un_effect_date >", value, "unEffectDate");
            return (Criteria) this;
        }

        public Criteria andUnEffectDateGreaterThanOrEqualTo(Date value) {
            addCriterion("un_effect_date >=", value, "unEffectDate");
            return (Criteria) this;
        }

        public Criteria andUnEffectDateLessThan(Date value) {
            addCriterion("un_effect_date <", value, "unEffectDate");
            return (Criteria) this;
        }

        public Criteria andUnEffectDateLessThanOrEqualTo(Date value) {
            addCriterion("un_effect_date <=", value, "unEffectDate");
            return (Criteria) this;
        }

        public Criteria andUnEffectDateIn(List<Date> values) {
            addCriterion("un_effect_date in", values, "unEffectDate");
            return (Criteria) this;
        }

        public Criteria andUnEffectDateNotIn(List<Date> values) {
            addCriterion("un_effect_date not in", values, "unEffectDate");
            return (Criteria) this;
        }

        public Criteria andUnEffectDateBetween(Date value1, Date value2) {
            addCriterion("un_effect_date between", value1, value2, "unEffectDate");
            return (Criteria) this;
        }

        public Criteria andUnEffectDateNotBetween(Date value1, Date value2) {
            addCriterion("un_effect_date not between", value1, value2, "unEffectDate");
            return (Criteria) this;
        }

        public Criteria andSiteCodeIsNull() {
            addCriterion("site_code is null");
            return (Criteria) this;
        }

        public Criteria andSiteCodeIsNotNull() {
            addCriterion("site_code is not null");
            return (Criteria) this;
        }

        public Criteria andSiteCodeEqualTo(String value) {
            addCriterion("site_code =", value, "siteCode");
            return (Criteria) this;
        }

        public Criteria andSiteCodeNotEqualTo(String value) {
            addCriterion("site_code <>", value, "siteCode");
            return (Criteria) this;
        }

        public Criteria andSiteCodeGreaterThan(String value) {
            addCriterion("site_code >", value, "siteCode");
            return (Criteria) this;
        }

        public Criteria andSiteCodeGreaterThanOrEqualTo(String value) {
            addCriterion("site_code >=", value, "siteCode");
            return (Criteria) this;
        }

        public Criteria andSiteCodeLessThan(String value) {
            addCriterion("site_code <", value, "siteCode");
            return (Criteria) this;
        }

        public Criteria andSiteCodeLessThanOrEqualTo(String value) {
            addCriterion("site_code <=", value, "siteCode");
            return (Criteria) this;
        }

        public Criteria andSiteCodeLike(String value) {
            addCriterion("site_code like", value, "siteCode");
            return (Criteria) this;
        }

        public Criteria andSiteCodeNotLike(String value) {
            addCriterion("site_code not like", value, "siteCode");
            return (Criteria) this;
        }

        public Criteria andSiteCodeIn(List<String> values) {
            addCriterion("site_code in", values, "siteCode");
            return (Criteria) this;
        }

        public Criteria andSiteCodeNotIn(List<String> values) {
            addCriterion("site_code not in", values, "siteCode");
            return (Criteria) this;
        }

        public Criteria andSiteCodeBetween(String value1, String value2) {
            addCriterion("site_code between", value1, value2, "siteCode");
            return (Criteria) this;
        }

        public Criteria andSiteCodeNotBetween(String value1, String value2) {
            addCriterion("site_code not between", value1, value2, "siteCode");
            return (Criteria) this;
        }

        public Criteria andChannelCodeIsNull() {
            addCriterion("channel_code is null");
            return (Criteria) this;
        }

        public Criteria andChannelCodeIsNotNull() {
            addCriterion("channel_code is not null");
            return (Criteria) this;
        }

        public Criteria andChannelCodeEqualTo(String value) {
            addCriterion("channel_code =", value, "channelCode");
            return (Criteria) this;
        }

        public Criteria andChannelCodeNotEqualTo(String value) {
            addCriterion("channel_code <>", value, "channelCode");
            return (Criteria) this;
        }

        public Criteria andChannelCodeGreaterThan(String value) {
            addCriterion("channel_code >", value, "channelCode");
            return (Criteria) this;
        }

        public Criteria andChannelCodeGreaterThanOrEqualTo(String value) {
            addCriterion("channel_code >=", value, "channelCode");
            return (Criteria) this;
        }

        public Criteria andChannelCodeLessThan(String value) {
            addCriterion("channel_code <", value, "channelCode");
            return (Criteria) this;
        }

        public Criteria andChannelCodeLessThanOrEqualTo(String value) {
            addCriterion("channel_code <=", value, "channelCode");
            return (Criteria) this;
        }

        public Criteria andChannelCodeLike(String value) {
            addCriterion("channel_code like", value, "channelCode");
            return (Criteria) this;
        }

        public Criteria andChannelCodeNotLike(String value) {
            addCriterion("channel_code not like", value, "channelCode");
            return (Criteria) this;
        }

        public Criteria andChannelCodeIn(List<String> values) {
            addCriterion("channel_code in", values, "channelCode");
            return (Criteria) this;
        }

        public Criteria andChannelCodeNotIn(List<String> values) {
            addCriterion("channel_code not in", values, "channelCode");
            return (Criteria) this;
        }

        public Criteria andChannelCodeBetween(String value1, String value2) {
            addCriterion("channel_code between", value1, value2, "channelCode");
            return (Criteria) this;
        }

        public Criteria andChannelCodeNotBetween(String value1, String value2) {
            addCriterion("channel_code not between", value1, value2, "channelCode");
            return (Criteria) this;
        }

        public Criteria andMemoIsNull() {
            addCriterion("memo is null");
            return (Criteria) this;
        }

        public Criteria andMemoIsNotNull() {
            addCriterion("memo is not null");
            return (Criteria) this;
        }

        public Criteria andMemoEqualTo(String value) {
            addCriterion("memo =", value, "memo");
            return (Criteria) this;
        }

        public Criteria andMemoNotEqualTo(String value) {
            addCriterion("memo <>", value, "memo");
            return (Criteria) this;
        }

        public Criteria andMemoGreaterThan(String value) {
            addCriterion("memo >", value, "memo");
            return (Criteria) this;
        }

        public Criteria andMemoGreaterThanOrEqualTo(String value) {
            addCriterion("memo >=", value, "memo");
            return (Criteria) this;
        }

        public Criteria andMemoLessThan(String value) {
            addCriterion("memo <", value, "memo");
            return (Criteria) this;
        }

        public Criteria andMemoLessThanOrEqualTo(String value) {
            addCriterion("memo <=", value, "memo");
            return (Criteria) this;
        }

        public Criteria andMemoLike(String value) {
            addCriterion("memo like", value, "memo");
            return (Criteria) this;
        }

        public Criteria andMemoNotLike(String value) {
            addCriterion("memo not like", value, "memo");
            return (Criteria) this;
        }

        public Criteria andMemoIn(List<String> values) {
            addCriterion("memo in", values, "memo");
            return (Criteria) this;
        }

        public Criteria andMemoNotIn(List<String> values) {
            addCriterion("memo not in", values, "memo");
            return (Criteria) this;
        }

        public Criteria andMemoBetween(String value1, String value2) {
            addCriterion("memo between", value1, value2, "memo");
            return (Criteria) this;
        }

        public Criteria andMemoNotBetween(String value1, String value2) {
            addCriterion("memo not between", value1, value2, "memo");
            return (Criteria) this;
        }
    }

    /**
     * product_price
     */
    public static class Criteria extends GeneratedCriteria {

        protected Criteria() {
            super();
        }
    }

    /**
     * @title product_price表的实体类
     * @description product_price
     * @version 1.0
     * @author 18304
     * @date 2020-11-24 15:43:05
     */
    public static class Criterion {
        private String condition;

        private Object value;

        private Object secondValue;

        private boolean noValue;

        private boolean singleValue;

        private boolean betweenValue;

        private boolean listValue;

        private String typeHandler;

        public String getCondition() {
            return condition;
        }

        public Object getValue() {
            return value;
        }

        public Object getSecondValue() {
            return secondValue;
        }

        public boolean isNoValue() {
            return noValue;
        }

        public boolean isSingleValue() {
            return singleValue;
        }

        public boolean isBetweenValue() {
            return betweenValue;
        }

        public boolean isListValue() {
            return listValue;
        }

        public String getTypeHandler() {
            return typeHandler;
        }

        protected Criterion(String condition) {
            super();
            this.condition = condition;
            this.typeHandler = null;
            this.noValue = true;
        }

        protected Criterion(String condition, Object value, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.typeHandler = typeHandler;
            if (value instanceof List<?>) {
                this.listValue = true;
            } else {
                this.singleValue = true;
            }
        }

        protected Criterion(String condition, Object value) {
            this(condition, value, null);
        }

        protected Criterion(String condition, Object value, Object secondValue, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.secondValue = secondValue;
            this.typeHandler = typeHandler;
            this.betweenValue = true;
        }

        protected Criterion(String condition, Object value, Object secondValue) {
            this(condition, value, secondValue, null);
        }
    }
}
